Labels:text | screenshot | number | parallel | font | document OCR: INFORMIX-ONLINE 7.2 MICROSOFT SQL IBM CA-OPENINGRES 1.2 SERVER 6.5 DB2 2.1.1 No No No Restrict, except cascading delete Restrict Restrict, cascada, set nu Restrict orly No No No No No No No No Yes fes, including ur on views Yes No Yes Yes Byte, text up to 2GB large object Byte, byte varying, lang byte, long varchar, money, spatial data types No choice No choice No choice B-tree, hash, heap, ISAM. B+ troo, clustered Clustered Clustered B.tree, hash, ISAM Extents, table fragmentation by: Fill factors; allocation Table and index allocation, cluster Fill factors, pre-allocation, table and expression tr round robin ratio, cluster factor index allocation Row based, bet-based Set-based Row based, set-based Row-based Before: for eachy, after Afte Bafare, after After Yes You Yes SP SOL & 3GL SQL-like Yes Yes Yes Yes Yes Yes No System calls No System calls No (database chents) User defined functions Database event ale ters Database, table, page, cow Database, table, page, row Database, table, page. row Database, table, pege Entry.Levill SC _ 92 Entry-Level SQL-92 Enty-Level SOL-92 Entry-Level SQL-92 Forward, backward Forward, Sockwars, relative, absoluta Forward Forward Yer Yes No No ESQL, TPIXA, CLI, ODBC ESOL, DaLB, Distributed Management ESOL, ODBC ESOL, TRIXA, ODBC Cojea19, ODBC SMI, DB/Cockpit, OnPerd Enterprise Manager, Performance Database Director, Visual Explain, IPM, VISUSIDBA,IMA Monitor Performance Monitor C2, B1 (OnLine/Secure) No Ye NT integrated Three levels C2 No Per-table: Por-tablo ESQL + 4GL CG: Interface Kit Interne: Information Server n \windows NT DA2 WAVW Connection CA-Oper Ingres/ICE Oracle, Sybase, IMS, DB2 No Orade, Sybase, Informix, MS SOL OB2, Detacom), AVIS, IDMS, VSAM, Server Oracle, ROB. Albase, Informix, Oracle, Sybase Online server Date Joiner CA-Openingrest Stir Yes, presumed abort No Yes, automatic No Through Data Jomer Through gateways Yes Yes No No Log Yes Rules (triggers) Yes Yes NO Yes Through ODBC Through DataJoinnr Through gateways No No 18 30 250 18 32 276 255 32.747 255 4005. except LOB 2008, except BLOB 2GB 477 million 2 billion Storage dependent 64 terabytes 2 terabytes 32,767 storage dependeist 2006, except BLOB Mast Unix systems, Windows Windows NT Most Unix systems, Windows NT, Mast Unix systoms, Windows NT NT, Windows 95 VAX VMS, Windows 95,OS/2, VAX VMS, Windows 95 (CA- Macintosh Openingres/Desktop]
